The following script can be applied to a custom import census column where the data is presented as "string", versus numbers.
 

Example:

Under the "Hours per Week" column, values are -
 
12.25
31.34
45.02

 

• They are presented as text/strings, not numbers.
• There are decimal values - importing does not [currently] recognize decimal values.
• Must be rounded to a whole number value to be accepted during the import.

The script is as follows:
 

var d = Convert.ToDecimal(Event.Record["Hours Per Week"]);

Event.Value = Math.round(d);

 

Explanation

Line 1 converts the value of what is found within the cells of "Hours Per Week" and converts them to a decimal (i.e., a number) value, then assigns the result to variable d.

Line 2 performs the rounding to a whole number (integer) on the variable.
 
The "Hours Per Week" references the column header, as provided by the client. This is illustrated here because the import was a custom import.
 
 
Alternative use:
 
In the event that the column's values are already numbers, a code similar to this can be applied to round the values to whole numbers:
 

d = Event.Record["Hours Per Week"];

Event.Value = Math.round(d);